To set up an XML data source, you must use the Merant ODBC driver, Crxml15.dll. The driver supports access to the following XML file types:
Note: This section provides a generic description of how to set up an XML data source. For examples of how to set up data sources for IE5 XML Data Islands and ADO 2.5 persisted XML, visit the Crystal Reports site at:
http://www.seagatesoftware.com/products/crystalreports
Note: Content on the Crystal Reports web site is available only in English.
The Merant driver requires an XML file structure that can be read like a database. Within an XML file, the first element encountered is considered the "table." Child elements of the node are considered the "rows." Child elements of the row nodes are considered "columns." Child elements of columns are considered part of the columns themselves. In the driver setup, you can use a Table Hint and/or a Row Hint to identify XSL patterns to be used as table and row nodes.
A Table Hint specifies an XSL pattern that indicates a table or rowset. Table Hints should point to a single node; otherwise, the first node in a set of nodes is used as the table node.
A Row Hint specifies an XSL pattern that indicates nodes to be used as rows in the table. The Row Hint also specifies whether the table content is based on an XML element or attribute type.
The Merant driver assumes that row nodes are the immediate children of the table node:
For examples of how to use hints, see Table and Row Hint examples.
The ODBC Data Source Administrator dialog box appears.
Note: Crystal Reports installs version 3.510 of the ODBC Data Source Administrator. If you have a different version, steps in this procedure will vary slightly.
The Create New Data Source dialog box appears.
The ODBC XML Driver Setup dialog box appears.
For examples of how to use hints, see Table and Row Hint examples.
For more information about other options on the Advanced and Options tabs, click the Help button on the ODBC XML Driver Setup dialog box.
You are returned to the ODBC Data Source Administrator. Your new XML data source is listed as a User Data Source.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |